Postgres Pro
Downloads
Home   >   mailing lists

Datetime in humane format - Mailing list pgsql-sql

From lynch@lscorp.com (Richard Lynch)
Subject Datetime in humane format
Date
Msg-id v02140b15b2177863c44f@[207.152.64.133]
Whole thread Raw
Responses Re: [SQL] Datetime in humane format  (Herouth Maoz <herouth@oumail.openu.ac.il>)
Re: [SQL] Datetime in humane format  (Eric McKeown <ericm@palaver.net>)
List pgsql-sql
Tree view 
So, I followed the advice in the archives and used the datetime type.

Now, I've got entries like 'Sun Sep 06 00:06:57 1998 EDT' in my table.

So, how do I turn that into something that a normal human can read?

"Sep 06 1998 12:06 am" would be nice...

Or, how do I turn that back into seconds since epoch?  I'm using PHP which
has a nice date function that I think I can coerce into giving me what I
want... unless it also thinks that humans understand 00:06:57 as just after
midnight...

--
--
-- "TANSTAAFL" Rich lynch@lscorp.com

pgsql-sql by date:

Previous
From: Andrew M Tracey
Date:
Subject: constraints don't work...
Next
From: Herouth Maoz
Date:
Subject: Re: [SQL] Datetime in humane format